DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`
(
    `id`                   bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `name`                 varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nickname`             varchar(128) COLLATE utf8mb4_unicode_ci          DEFAULT NULL,
    `avatar`               varchar(255) COLLATE utf8mb4_unicode_ci          DEFAULT NULL,
    `email`                varchar(64) COLLATE utf8mb4_unicode_ci           DEFAULT NULL,
    `phone`                varchar(32) COLLATE utf8mb4_unicode_ci           DEFAULT NULL,
    `email_verified_at`    timestamp                               NULL     DEFAULT NULL,
    `password`             varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pay_password`         varchar(255) COLLATE utf8mb4_unicode_ci          DEFAULT NULL COMMENT '支付密码',
    `rid`                  bigint(20) unsigned                     NOT NULL DEFAULT '0' COMMENT '推荐人',
    `google_captcha`       varchar(128) COLLATE utf8mb4_unicode_ci          DEFAULT NULL COMMENT '谷歌验证码',
    `google_captcha_new`   varchar(128) COLLATE utf8mb4_unicode_ci          DEFAULT NULL COMMENT '新的谷歌验证码',
    `google_captcha_check` tinyint(4)                                       DEFAULT '0' COMMENT '谷歌验证码确认 0未确认 1确认',
    `status`               tinyint(4)                                       DEFAULT '1' COMMENT '状态 1启用 0禁用',
    `ip`                   varchar(128) COLLATE utf8mb4_unicode_ci          DEFAULT NULL COMMENT 'IP',
    `invite_code`          varchar(16) COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '邀请码',
    `register_type`        tinyint(4)                              NOT NULL DEFAULT '1' COMMENT '1邮箱注册 2手机号注册',
    `area_id`              int(11)                                 NOT NULL DEFAULT '0' COMMENT '地区',
    `created_at`           timestamp                               NULL     DEFAULT NULL,
    `updated_at`           timestamp                               NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_name` (`name`),
    UNIQUE KEY `idx_invite_code` (`invite_code`),
    KEY `pid` (`rid`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 80000000
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `user_trees`;
CREATE TABLE `user_trees`
(
    `id`          int(11)   NOT NULL AUTO_INCREMENT,
    `uid`         int(11)        DEFAULT '0' COMMENT '注册用户id',
    `pid`         int(11)        DEFAULT '0' COMMENT '用户上级id',
    `distance`    tinyint(4)     DEFAULT '0' COMMENT '距离',
    `register_at` timestamp NULL DEFAULT NULL COMMENT '注册时间',
    PRIMARY KEY (`id`),
    KEY `user_id` (`uid`) USING BTREE,
    KEY `user_pid` (`pid`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
    COMMENT ='用户树';

DROP TABLE IF EXISTS `user_assets`;
CREATE TABLE `user_assets`
(
    `id`           int(11)   NOT NULL AUTO_INCREMENT,
    `uid`          int(11)         DEFAULT NULL COMMENT '用户ID',
    `symbol`       varchar(32)     DEFAULT NULL COMMENT '币种标记',
    `balance`      decimal(40, 18) DEFAULT 0 COMMENT '余额',
    `balance_lock` decimal(40, 18) DEFAULT 0 COMMENT '锁定余额',
    `created_at`   timestamp NULL  DEFAULT NULL COMMENT '创建时间',
    `updated_at`   timestamp NULL  DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT ='资产';

DROP TABLE IF EXISTS `asset_logs`;
CREATE TABLE `asset_logs`
(
    `id`         bigint(20) NOT NULL AUTO_INCREMENT,
    `uid`        int(11)         DEFAULT NULL COMMENT '用户ID',
    `rid`        int(11)         DEFAULT 0 COMMENT '推荐用户',
    `symbol`     varchar(32)     DEFAULT NULL COMMENT '币种标识',
    `type`       int(11)         DEFAULT 0 COMMENT '业务类型',
    `amount`     decimal(40, 18) DEFAULT '0.00000000' COMMENT '金额',
    `balance`    decimal(40, 18) DEFAULT '0.00000000' COMMENT '帐变后余额',
    `related_sn` varchar(128)    DEFAULT NULL COMMENT '关联业务单号',
    `remark`     varchar(256) COMMENT '备注',
    `created_at` timestamp  NULL DEFAULT NULL COMMENT '创建时间',
    `updated_at` timestamp  NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE,
    KEY `uid_symbol` (`uid`, `symbol`) USING BTREE,
    KEY `created_at` (`created_at`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
    COMMENT ='资产日志';


DROP TABLE IF EXISTS `user_deposit_methods`;
CREATE TABLE `user_deposit_methods`
(
    `id`         int(11)   NOT NULL AUTO_INCREMENT,
    `name`       varchar(32)    DEFAULT NULL COMMENT '名称',
    `type`       int(11)        DEFAULT 1 COMMENT '类型 1链 2银行卡',
    `params`     text           DEFAULT NULL COMMENT '参数',
    `status`     int(11)        DEFAULT 1 COMMENT '状态 0关 1开',
    `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
    COMMENT ='充值方式';

DROP TABLE IF EXISTS `user_deposits`;
CREATE TABLE `user_deposits`
(
    `id`           int(11)   NOT NULL AUTO_INCREMENT,
    `uid`          int(11)         DEFAULT NULL COMMENT '用户id',
    `from_symbol`  varchar(32)     DEFAULT NULL COMMENT '来源币',
    `from_amount`  decimal(40, 18) DEFAULT NULL COMMENT '来源数量',
    `to_symbol`    varchar(32)     DEFAULT NULL COMMENT '目标币',
    `to_amount`    decimal(40, 18) DEFAULT NULL COMMENT '目标数量',
    `rate`         decimal(40, 18) DEFAULT NULL COMMENT '汇率',
    `user_account` varchar(64)     DEFAULT NULL COMMENT '账户号',
    `user_name`    varchar(64)     DEFAULT NULL COMMENT '账户名称',
    `to_address`   varchar(64)     DEFAULT NULL COMMENT '转出地址',
    `status`       int(11)         DEFAULT 1 COMMENT '状态 1提交 2成功 3失败',
    `remark`       varchar(255)    DEFAULT NULL COMMENT '备注',
    `image`        varchar(255)    DEFAULT NULL COMMENT '图片',
    `method_id`    int(11)         DEFAULT 1 COMMENT '充值方式',
    `executed_tx`  varchar(128)    DEFAULT NULL COMMENT '执行哈希',
    `executed_at`  timestamp NULL  DEFAULT NULL COMMENT '执行完成时间',
    `created_at`   timestamp NULL  DEFAULT NULL COMMENT '创建时间',
    `updated_at`   timestamp NULL  DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
    COMMENT ='充值订单';


DROP TABLE IF EXISTS `user_withdraws`;
CREATE TABLE `user_withdraws`
(
    `id`           int(11)   NOT NULL AUTO_INCREMENT,
    `uid`          int(11)         DEFAULT NULL COMMENT '用户id',
    `from_symbol`  varchar(32)     DEFAULT NULL COMMENT '来源币',
    `from_amount`  decimal(40, 18) DEFAULT NULL COMMENT '来源数量',
    `to_symbol`    varchar(32)     DEFAULT NULL COMMENT '目标币',
    `to_amount`    decimal(40, 18) DEFAULT NULL COMMENT '目标数量',
    `rate`         decimal(40, 18) DEFAULT NULL COMMENT '汇率',
    `from_address` varchar(64)     DEFAULT NULL COMMENT '转入地址',
    `to_address`   varchar(64)     DEFAULT NULL COMMENT '转出地址',
    `status`       int(11)         DEFAULT 1 COMMENT '状态 1提交 2成功 3失败',
    `fee_symbol`   decimal(40, 18) DEFAULT NULL COMMENT '手续费币',
    `fee`          decimal(40, 18) DEFAULT NULL COMMENT '手续费',
    `remark`       varchar(255)    DEFAULT NULL COMMENT '备注',
    `executed_at`  int(11)         DEFAULT NULL COMMENT '执行完成时间',
    `executed_tx`  varchar(255)    DEFAULT NULL COMMENT '执行哈希',
    `created_at`   timestamp NULL  DEFAULT NULL COMMENT '创建时间',
    `updated_at`   timestamp NULL  DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci
    COMMENT ='提现订单';


ALTER TABLE `users`
    ADD COLUMN `user_hierarchy` int(11) NOT NULL DEFAULT 0 COMMENT '推荐层级' after `area_id`;

ALTER TABLE `users`
    ADD COLUMN `is_agent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否代理' after `area_id`;

ALTER TABLE `users`
    ADD COLUMN `agent_path` varchar(1024) NOT NULL DEFAULT '1' COMMENT '代理层' after `area_id`;

ALTER TABLE `users`
    ADD COLUMN `agent_referer` int(11) DEFAULT 1 COMMENT '推荐代理' after `area_id`;

DROP TABLE IF EXISTS `content_category`;
CREATE TABLE `content_category`
(
    `id`         int(11)    NOT NULL AUTO_INCREMENT,
    `sn`         varchar(255)        DEFAULT NULL COMMENT 'sn',
    `primary_id` int(11)             DEFAULT NULL COMMENT '主类，配合lang使用',
    `name`       varchar(255)        DEFAULT NULL COMMENT '类名',
    `lang`       varchar(255)        DEFAULT NULL COMMENT '语言',
    `weight`     int(11)             DEFAULT '1' COMMENT '排序权重',
    `created_at` int(11)             DEFAULT NULL COMMENT '创建时间',
    `updated_at` int(11)             DEFAULT NULL COMMENT '更新时间',
    `deleted_at` int(11)             DEFAULT NULL COMMENT '删除时间',
    `show`       tinyint(2) NOT NULL DEFAULT '0' COMMENT '首页是否显示；0：不显示，1：显示',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 1036
  DEFAULT CHARSET = utf8mb4 COMMENT ='文章类别';


DROP TABLE IF EXISTS `contents`;
CREATE TABLE `contents`
(
    `id`           int(11) NOT NULL AUTO_INCREMENT,
    `type`         int(11)      DEFAULT NULL COMMENT '类型',
    `alias`        varchar(128) DEFAULT NULL COMMENT '内容别名',
    `lang`         varchar(128) DEFAULT NULL COMMENT '语言',
    `image`        varchar(255) DEFAULT NULL COMMENT '主图',
    `image_width`  int(11)      DEFAULT NULL COMMENT '图片宽度',
    `image_height` int(11)      DEFAULT NULL COMMENT '图片高度',
    `url`          varchar(255) DEFAULT NULL COMMENT '链接',
    `title`        varchar(255) DEFAULT NULL COMMENT '标题',
    `description`  text COMMENT '简述',
    `body`         text COMMENT '正文',
    `weight`       int(11)      DEFAULT '1' COMMENT '排序权重',
    `status`       smallint(3)  DEFAULT '10' COMMENT '状态',
    `is_home`      smallint(3)  DEFAULT '0' COMMENT '首页显示',
    `category_id`  int(11)      DEFAULT '0' COMMENT '分类ID',
    `created_at`   int(11)      DEFAULT NULL COMMENT '创建时间',
    `updated_at`   int(11)      DEFAULT NULL COMMENT '更新时间',
    `deleted_at`   int(11)      DEFAULT NULL COMMENT '删除时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 23
  DEFAULT CHARSET = utf8mb4 COMMENT ='文章表';


ALTER TABLE `user_assets`
    ADD COLUMN `used_balance` decimal(40, 18) unsigned DEFAULT 0 COMMENT '持仓保证金' after `balance_lock`;

ALTER TABLE `user_assets`
    ADD COLUMN `freeze_balance` decimal(40, 18) unsigned DEFAULT 0 COMMENT '委托冻结' after `balance_lock`;


DROP TABLE IF EXISTS `user_auth`;
CREATE TABLE `user_auth`
(
    `id`             int(11)      NOT NULL AUTO_INCREMENT,
    `uid`            int(11)      NOT NULL COMMENT '用户ID',
    `country_id`     int(11)               DEFAULT NULL,
    `country_code`   varchar(30)           DEFAULT NULL COMMENT '国家代码',
    `realname`       varchar(55)  NOT NULL COMMENT '真实姓名',
    `id_card`        varchar(255) NOT NULL COMMENT '证件号码',
    `birthday`       varchar(50)           DEFAULT NULL COMMENT '出生日期',
    `address`        varchar(255)          DEFAULT NULL COMMENT '居住地址',
    `city`           varchar(30)           DEFAULT NULL COMMENT '城市',
    `postal_code`    varchar(30)           DEFAULT NULL COMMENT '邮政编码',
    `extra`          varchar(255)          DEFAULT NULL COMMENT '额外信息',
    `phone`          varchar(30)           DEFAULT NULL COMMENT '电话号码',
    `type`           tinyint(1)   NOT NULL DEFAULT '1' COMMENT '证件类型 默认1身份证',
    `front_img`      varchar(255)          DEFAULT NULL COMMENT '正面照',
    `back_img`       varchar(255)          DEFAULT NULL COMMENT '背面照',
    `hand_img`       varchar(255)          DEFAULT NULL COMMENT '手持照',
    `check_time`     timestamp    NULL     DEFAULT NULL COMMENT '审核时间',
    `primary_status` tinyint(1)            DEFAULT '1' COMMENT '初级认证状态 1已认证',
    `status`         tinyint(1)            DEFAULT '0' COMMENT '高级认证状态 0未认证,1待审核,2已通过,3已驳回',
    `remark`         varchar(255)          DEFAULT NULL,
    `created_at`     timestamp    NULL     DEFAULT NULL,
    `updated_at`     timestamp    NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;


-- 20220921
ALTER TABLE `asset_logs`
    ADD COLUMN `balance_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '余额类型' after `remark`;


-- 20220922

ALTER TABLE `users`
    ADD COLUMN `trade_status` int(11) DEFAULT 1 COMMENT '交易状态0 关闭 1开启' after `user_hierarchy`;

ALTER TABLE `users`
    ADD COLUMN `risk` int(11) DEFAULT 3 COMMENT '输赢 1赢 2输 3不干预' after `trade_status`;


-- 20220927
ALTER TABLE `user_withdraws`
    ADD `real_amount` decimal(40, 18) DEFAULT 0 COMMENT '实际到账' AFTER `executed_tx`;

ALTER TABLE `user_withdraws`
    MODIFY COLUMN `fee_symbol` varchar(32) NULL DEFAULT NULL COMMENT '手续费币' AFTER `status`;

ALTER TABLE `user_withdraws`
    MODIFY COLUMN `executed_at` timestamp NULL DEFAULT NULL COMMENT '执行完成时间' AFTER `remark`;


DROP TABLE IF EXISTS `user_notifications`;
CREATE TABLE `user_notifications`
(
    `id`         int(11)          NOT NULL AUTO_INCREMENT,
    `uid`        int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
    `type`       tinyint(4)       NOT NULL DEFAULT '0' COMMENT '类型 1充值成功 2充值失败 3提现成功 4提现失败',
    `amount`     decimal(40, 18)  NOT NULL DEFAULT '0' COMMENT '金额',
    `read`       tinyint(1)       NOT NULL DEFAULT '0' COMMENT '是否已读 1已读 0未读',
    `created_at` timestamp        NULL     DEFAULT NULL,
    `updated_at` timestamp        NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT ='用户消息';


-- 20220928
ALTER TABLE `users`
    ADD COLUMN `is_sign` tinyint(4) DEFAULT 0 COMMENT '是否签约 1是 2否' after `area_id`;

ALTER TABLE `user_deposits`
    ADD COLUMN `is_settle` tinyint(1) DEFAULT 0 COMMENT '1结算 0未结算' after `executed_at`;

ALTER TABLE `users`
    ADD COLUMN `sign_status` tinyint(4) DEFAULT 0 COMMENT '签约状态 0未申请 1审核中 2申请通过' after `area_id`;


-- 2022-10-08
ALTER TABLE `user_assets`
    ADD `freeze_all` decimal(40, 18) DEFAULT 0 COMMENT '冻结金额(除了委托保证金冻结)' AFTER `id`;


ALTER TABLE `user_deposits`
    ADD `order_sn` varchar(64) DEFAULT NULL COMMENT '订单号' AFTER `id`;

ALTER TABLE `user_deposits`
    ADD `third_name` varchar(64) DEFAULT NULL COMMENT '三方名称' AFTER `order_sn`;

-- 2022-10-11
ALTER TABLE `users`
    ADD `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理账户id' after `risk`;
insert into users(`id`, `name`, `email`, `invite_code`, `admin_id`, `password`, `created_at`)
values (1, "admin", "admin@163.com", "DDD222", 1, '$2y$10$7TJLsbqavsQ4zZj8wpY6AOmIhqO8PuWMEBbl1B3OMdbPT9q79VtoK',
        '2022-09-16 16:11:39');

insert into user_assets(`uid`, `symbol`)
values (1, "USD");

-- 2022-10-13
ALTER TABLE `user_assets`
    ADD `deposit_history` decimal(40, 18) DEFAULT 0 COMMENT '历史充值' AFTER `used_balance`;

ALTER TABLE `asset_logs`
    ADD COLUMN `is_settle` tinyint(1) DEFAULT 0 COMMENT '1结算 0未结算' after `balance_type`;

ALTER TABLE `user_deposits`
    ADD `to_real_amount` decimal(40, 18) DEFAULT 0 COMMENT '实际到账' after `to_amount`;


DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log`
(
    `id`         bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `user_id`    bigint(20)                              NOT NULL,
    `path`       varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `method`     varchar(10) COLLATE utf8mb4_unicode_ci  NOT NULL,
    `ip`         varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `input`      text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `created_at` timestamp                               NULL DEFAULT NULL,
    `updated_at` timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `admin_settings`;
CREATE TABLE `admin_settings`
(
    `slug`       varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value`      longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `created_at` timestamp                               NULL DEFAULT NULL,
    `updated_at` timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`slug`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;



DROP TABLE IF EXISTS `user_wallet`;
CREATE TABLE `user_wallet`
(
    `id`           int(11)      NOT NULL AUTO_INCREMENT,
    `uid`          int(11)           DEFAULT 0 COMMENT '用户id',
    `address`      varchar(255) NOT NULL COMMENT '钱包地址',
    `key`          varchar(255) NOT NULL COMMENT 'key',
    `system_value` decimal(40, 18)   DEFAULT 0 COMMENT '代币余额',
    `value`        decimal(40, 18)   DEFAULT 0 COMMENT 'USDT余额',
    `status`       int(11)           DEFAULT 0 COMMENT '0禁用 1启用',
    `sort`         int(11)           DEFAULT 0 COMMENT '排序',
    `created_at`   timestamp    NULL DEFAULT NULL,
    `updated_at`   timestamp    NULL DEFAULT NULL,
    PRIMARY KEY (id),
    KEY uid (uid) USING BTREE,
    KEY `idxaddress` (`address`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4 COMMENT ='钱包配置';

DROP TABLE IF EXISTS `user_withdraws`;
CREATE TABLE `user_withdraws`
(
    `id`           int(11)   NOT NULL AUTO_INCREMENT,
    `uid`          int(11)                                 DEFAULT NULL COMMENT '用户id',
    `from_symbol`  varchar(32) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '来源币',
    `from_amount`  decimal(40, 18)                         DEFAULT NULL COMMENT '来源数量',
    `to_symbol`    varchar(32) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '目标币',
    `to_amount`    decimal(40, 18)                         DEFAULT NULL COMMENT '目标数量',
    `rate`         decimal(40, 18)                         DEFAULT NULL COMMENT '汇率',
    `from_address` varchar(64) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '转入地址',
    `to_address`   varchar(64) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '转出地址',
    `status`       int(11)                                 DEFAULT '1' COMMENT '状态 1提交 2成功 3失败',
    `fee_symbol`   varchar(32) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '手续费币',
    `fee`          decimal(40, 18)                         DEFAULT NULL COMMENT '手续费',
    `remark`       varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
    `executed_at`  timestamp NULL                          DEFAULT NULL COMMENT '执行完成时间',
    `executed_tx`  varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '执行哈希',
    `real_amount`  decimal(40, 18)                         DEFAULT '0.000000000000000000' COMMENT '实际到账',
    `created_at`   timestamp NULL                          DEFAULT NULL COMMENT '创建时间',
    `updated_at`   timestamp NULL                          DEFAULT NULL COMMENT '更新时间',
    `contract`     varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '合约',
    `chain`        varchar(64) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '链',
    `tx_status`    int(11)                                 DEFAULT '0' COMMENT '链状态',
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci COMMENT ='提现订单';

/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50739
 Source Host           : localhost:3306
 Source Schema         : tg_admin

 Target Server Type    : MySQL
 Target Server Version : 50739
 File Encoding         : 65001

 Date: 08/01/2024 04:15:52
*/

SET NAMES utf8mb4;
SET
    FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_extension_histories
-- ----------------------------
DROP TABLE IF EXISTS `admin_extension_histories`;
CREATE TABLE `admin_extension_histories`
(
    `id`         bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `name`       varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type`       tinyint(4)                              NOT NULL DEFAULT '1',
    `version`    varchar(20) COLLATE utf8mb4_unicode_ci  NOT NULL DEFAULT '0',
    `detail`     text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp                               NULL     DEFAULT NULL,
    `updated_at` timestamp                               NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_extension_histories_name_index` (`name`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 6
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_extension_histories
-- ----------------------------
BEGIN;
INSERT INTO `admin_extension_histories` (`id`, `name`, `type`, `version`, `detail`, `created_at`, `updated_at`)
VALUES (1, 'dcat-admin.operation-log', 2, '1.0.0', 'create_opration_log_table.php', '2023-12-24 06:17:50',
        '2023-12-24 06:17:50');
INSERT INTO `admin_extension_histories` (`id`, `name`, `type`, `version`, `detail`, `created_at`, `updated_at`)
VALUES (2, 'dcat-admin.operation-log', 1, '1.0.0', 'Initialize extension.', '2023-12-24 06:17:50',
        '2023-12-24 06:17:50');
INSERT INTO `admin_extension_histories` (`id`, `name`, `type`, `version`, `detail`, `created_at`, `updated_at`)
VALUES (3, 'ghost.dcat-config', 1, 'v1.0.1', '优化显示页面', '2024-01-07 18:06:47', '2024-01-07 18:06:47');
INSERT INTO `admin_extension_histories` (`id`, `name`, `type`, `version`, `detail`, `created_at`, `updated_at`)
VALUES (4, 'ghost.dcat-config', 1, 'v1.0.6', '修复中文翻译失效', '2024-01-07 18:06:47', '2024-01-07 18:06:47');
INSERT INTO `admin_extension_histories` (`id`, `name`, `type`, `version`, `detail`, `created_at`, `updated_at`)
VALUES (5, 'ghost.dcat-config', 1, 'v1.0.7', '修复label翻译错误', '2024-01-07 18:06:47', '2024-01-07 18:06:47');
COMMIT;

-- ----------------------------
-- Table structure for admin_extensions
-- ----------------------------
DROP TABLE IF EXISTS `admin_extensions`;
CREATE TABLE `admin_extensions`
(
    `id`         int(10) unsigned                        NOT NULL AUTO_INCREMENT,
    `name`       varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `version`    varchar(20) COLLATE utf8mb4_unicode_ci  NOT NULL DEFAULT '',
    `is_enabled` tinyint(4)                              NOT NULL DEFAULT '0',
    `options`    text COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp                               NULL     DEFAULT NULL,
    `updated_at` timestamp                               NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_extensions_name_unique` (`name`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 3
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_extensions
-- ----------------------------
BEGIN;
INSERT INTO `admin_extensions` (`id`, `name`, `version`, `is_enabled`, `options`, `created_at`, `updated_at`)
VALUES (1, 'dcat-admin.operation-log', '1.0.0', 1, NULL, '2023-12-24 06:17:50', '2023-12-24 06:17:51');
INSERT INTO `admin_extensions` (`id`, `name`, `version`, `is_enabled`, `options`, `created_at`, `updated_at`)
VALUES (2, 'ghost.dcat-config', 'v1.0.7', 1, NULL, '2024-01-07 18:06:47', '2024-01-07 18:06:48');
COMMIT;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu`
(
    `id`         bigint(20) unsigned                    NOT NULL AUTO_INCREMENT,
    `parent_id`  bigint(20)                             NOT NULL DEFAULT '0',
    `order`      int(11)                                NOT NULL DEFAULT '0',
    `title`      varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon`       varchar(50) COLLATE utf8mb4_unicode_ci          DEFAULT NULL,
    `uri`        varchar(50) COLLATE utf8mb4_unicode_ci          DEFAULT NULL,
    `extension`  varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `show`       tinyint(4)                             NOT NULL DEFAULT '1',
    `created_at` timestamp                              NULL     DEFAULT NULL,
    `updated_at` timestamp                              NULL     DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 23
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (1, 0, 1, 'Index', 'feather icon-bar-chart-2', '/dashboard', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (2, 0, 2, 'Admin', 'feather icon-settings', '', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (3, 2, 3, 'Users', '', 'auth/users', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (4, 2, 4, 'Roles', '', 'auth/roles', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (5, 2, 5, 'Permission', '', 'auth/permissions', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (6, 2, 6, 'Menu', '', 'auth/menu', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`, `created_at`,
                          `updated_at`)
VALUES (7, 2, 7, 'Extensions', '', 'auth/extensions', '', 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`,
                          `created_at`, `updated_at`)
VALUES (8, 0, 8, 'Config', 'fa-toggle-off', 'config', 'ghost.dcat-config', 1, '2023-12-20 08:47:17',
        '2023-12-20 08:47:17');
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `extension`, `show`,
                          `created_at`, `updated_at`)
VALUES (9, 2, 9, 'Operation Log', NULL, 'auth/operation-logs', 'dcat-admin.operation-log', 1, '2023-12-20 08:47:19',
        '2023-12-20 08:47:48');
COMMIT;

-- ----------------------------
-- Table structure for admin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log`
(
    `id`         bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `user_id`    bigint(20)                              NOT NULL,
    `path`       varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `method`     varchar(10) COLLATE utf8mb4_unicode_ci  NOT NULL,
    `ip`         varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `input`      text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `created_at` timestamp                               NULL DEFAULT NULL,
    `updated_at` timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 53
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (1, 1, 'admin/auth/menu/8', 'PUT', '127.0.0.1',
        '{\"parent_id\":\"2\",\"title\":\"Operation Log\",\"icon\":null,\"uri\":\"auth\\/operation-logs\",\"show\":\"1\",\"roles\":[null],\"permissions\":null,\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/menu?s=%2Fadmin%2Fauth%2Fmenu\",\"_token\":\"8oNpKo3ZDqxNGcWsaEUcMLMXnvPqfllAVxtgS7Hd\",\"s\":\"\\/admin\\/auth\\/menu\\/8\"}',
        '2023-12-24 06:18:04', '2023-12-24 06:18:04');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (2, 0, 'admin/auth/login', 'POST', '127.0.0.1',
        '{\"_token\":\"vBBRcRuvMaPtUCzVcJFJ6uZ8h24SwfJh18cQmjcz\",\"username\":\"admin\",\"password\":\"adm******\",\"s\":\"\\/admin\\/auth\\/login\"}',
        '2023-12-24 14:48:01', '2023-12-24 14:48:01');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (3, 0, 'admin/auth/login', 'POST', '127.0.0.1',
        '{\"_token\":\"QXUdIcL8LbwKnEHX3ZT3RcuG0OV665hzpzEhL9F2\",\"username\":\"admin\",\"password\":\"adm******\",\"s\":\"\\/admin\\/auth\\/login\"}',
        '2023-12-24 17:48:59', '2023-12-24 17:48:59');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (4, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":null,\"title\":\"TG管理\",\"icon\":\"fa-address-book\",\"uri\":null,\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:49:21', '2023-12-24 17:49:21');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (5, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"TG管理員\",\"icon\":null,\"uri\":\"tg-admin\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:50:08', '2023-12-24 17:50:08');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (6, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"TG群組\",\"icon\":null,\"uri\":\"tg-group\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:50:26', '2023-12-24 17:50:26');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (7, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"分銷渠道\",\"icon\":null,\"uri\":\"tg-channel\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:50:59', '2023-12-24 17:50:59');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (8, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"tg配置\",\"icon\":null,\"uri\":\"tg-config\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:51:27', '2023-12-24 17:51:27');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (9, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"渠道餘額\",\"icon\":null,\"uri\":\"tg-channel-balance\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:51:56', '2023-12-24 17:51:56');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (10, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"出款任務\",\"icon\":null,\"uri\":\"tg-tasks\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:52:25', '2023-12-24 17:52:25');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (11, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"交易記錄\",\"icon\":null,\"uri\":\"tg-transactions\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:52:51', '2023-12-24 17:52:51');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (12, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"9\",\"title\":\"TGB價格時間綫\",\"icon\":null,\"uri\":\"tg-timeline\",\"roles\":[null],\"permissions\":null,\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2023-12-24 17:53:15', '2023-12-24 17:53:15');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (13, 1, 'admin/auth/roles', 'POST', '127.0.0.1',
        '{\"slug\":\"agent\",\"name\":\"代理\",\"permissions\":null,\"menus\":null,\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/roles?s=%2Fadmin%2Fauth%2Froles\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/roles\"}',
        '2023-12-24 18:02:53', '2023-12-24 18:02:53');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (14, 1, 'admin/auth/users', 'POST', '127.0.0.1',
        '{\"username\":\"agent\",\"name\":\"agent\",\"avatar\":null,\"_file_\":null,\"password\":\"123******\",\"password_confirmation\":\"123******\",\"roles\":\"2\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\"}',
        '2023-12-24 18:07:09', '2023-12-24 18:07:09');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (15, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":null,\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:19:11', '2023-12-24 18:19:11');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (16, 1, 'admin/auth/roles/2', 'PUT', '127.0.0.1',
        '{\"slug\":\"finance\",\"name\":\"财务\",\"permissions\":null,\"menus\":null,\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/roles?s=%2Fadmin%2Fauth%2Froles\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/roles\\/2\"}',
        '2023-12-24 18:19:29', '2023-12-24 18:19:29');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (17, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"2\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:29:29', '2023-12-24 18:29:29');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (18, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"2\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:30:50', '2023-12-24 18:30:50');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (19, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务1\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"2\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:31:51', '2023-12-24 18:31:51');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (20, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务1\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"2\",\"_method\":\"PUT\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:33:59', '2023-12-24 18:33:59');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (21, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务1\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"1\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:37:19', '2023-12-24 18:37:19');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (22, 1, 'admin/auth/users/2', 'PUT', '127.0.0.1',
        '{\"username\":\"finance\",\"name\":\"财务1\",\"avatar\":null,\"_file_\":null,\"password\":null,\"password_confirmation\":null,\"roles\":\"2\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/auth\\/users?s=%2Fadmin%2Fauth%2Fusers\",\"_token\":\"4jwYytQvnBbRmrwfNnZL7vEKbwld3cF2JD2Sqb2O\",\"s\":\"\\/admin\\/auth\\/users\\/2\"}',
        '2023-12-24 18:48:35', '2023-12-24 18:48:35');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (23, 0, 'admin/auth/login', 'POST', '127.0.0.1',
        '{\"_token\":\"fkBW0bz5SuX2lc3FFt8uh42uMGAa9OkZhLi8TXAc\",\"username\":\"admin\",\"password\":\"adm******\",\"s\":\"\\/admin\\/auth\\/login\"}',
        '2024-01-07 17:27:35', '2024-01-07 17:27:35');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (24, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"10\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:05:46', '2024-01-07 18:05:46');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (25, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"9\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:05:55', '2024-01-07 18:05:55');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (26, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"9\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:09', '2024-01-07 18:06:09');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (27, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"11\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:12', '2024-01-07 18:06:12');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (28, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"10\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:17', '2024-01-07 18:06:17');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (29, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Menu_Show\",\"_key\":\"11\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:19', '2024-01-07 18:06:19');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (30, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Extensions_Update\",\"_key\":\"ghost.dcat-config\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:47', '2024-01-07 18:06:47');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (31, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"_action\":\"Dcat_Admin_Http_Actions_Extensions_Enable\",\"_key\":\"ghost.dcat-config\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 18:06:48', '2024-01-07 18:06:48');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (32, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":null,\"title\":\"出款管理\",\"icon\":\"fa-address-card\",\"uri\":null,\"roles\":[null],\"permissions\":null,\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2024-01-07 18:08:13', '2024-01-07 18:08:13');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (33, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"19\",\"title\":\"出款配置\",\"icon\":null,\"uri\":\"user-wallet\",\"roles\":[null],\"permissions\":null,\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2024-01-07 18:14:30', '2024-01-07 18:14:30');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (34, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"19\",\"title\":\"提现管理\",\"icon\":null,\"uri\":\"user-withdraw\",\"roles\":[null],\"permissions\":null,\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2024-01-07 18:14:47', '2024-01-07 18:14:47');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (35, 1, 'admin/auth/menu', 'POST', '127.0.0.1',
        '{\"parent_id\":\"19\",\"title\":\"资金流水\",\"icon\":null,\"uri\":\"asset-log\",\"roles\":[null],\"permissions\":null,\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/auth\\/menu\"}',
        '2024-01-07 18:38:35', '2024-01-07 18:38:35');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (36, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:54:12', '2024-01-07 18:54:12');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (37, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:56:42', '2024-01-07 18:56:42');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (38, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:57:36', '2024-01-07 18:57:36');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (39, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:57:53', '2024-01-07 18:57:53');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (40, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:59:04', '2024-01-07 18:59:04');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (41, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"2\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:59:21', '2024-01-07 18:59:21');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (42, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"2\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:59:34', '2024-01-07 18:59:34');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (43, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"10\",\"balance_type\":\"2\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 18:59:57', '2024-01-07 18:59:57');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (44, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"1000\",\"balance_type\":\"1\",\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\AssetUpdateForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"5\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_AssetUpdateForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:21:32', '2024-01-07 19:21:32');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (45, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"100\",\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\SettleAccountForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_SettleAccountForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:23:03', '2024-01-07 19:23:03');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (46, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"100\",\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\SettleAccountForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_SettleAccountForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:23:30', '2024-01-07 19:23:30');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (47, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"100\",\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\SettleAccountForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_SettleAccountForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:24:18', '2024-01-07 19:24:18');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (48, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"status\":\"3\",\"remark\":\"10\",\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\Withdraw\\\\WithdrawCheckForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/user-withdraw?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/user-withdraw?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"16307\\\",\\\"renderable\\\":\\\"App_Admin_Forms_Withdraw_WithdrawCheckForm\\\",\\\"_trans_\\\":\\\"user-withdraw\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:34:38', '2024-01-07 19:34:38');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (49, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"amount\":\"100\",\"_form_\":\"App\\\\Admin\\\\Forms\\\\User\\\\SettleAccountForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/tg-channel-balance?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/tg-channel-balance?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"renderable\\\":\\\"App_Admin_Forms_User_SettleAccountForm\\\",\\\"_trans_\\\":\\\"tg-channel-balance\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:36:47', '2024-01-07 19:36:47');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (50, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\Withdraw\\\\SendTxForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/user-withdraw?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/user-withdraw?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"16308\\\",\\\"chain\\\":\\\"TRON\\\",\\\"renderable\\\":\\\"App_Admin_Forms_Withdraw_SendTxForm\\\",\\\"_trans_\\\":\\\"user-withdraw\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:42:10', '2024-01-07 19:42:10');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (51, 1, 'admin/dcat-api/form', 'POST', '127.0.0.1',
        '{\"remark\":null,\"id\":null,\"_form_\":\"App\\\\Admin\\\\Forms\\\\Withdraw\\\\SendTxForm\",\"_current_\":\"http:\\/\\/d.tgadmin.com\\/admin\\/user-withdraw?\",\"_payload_\":\"{\\\"_current_\\\":\\\"http:\\\\\\/\\\\\\/d.tgadmin.com\\\\\\/admin\\\\\\/user-withdraw?\\\",\\\"s\\\":\\\"\\\\\\/admin\\\\\\/dcat-api\\\\\\/render\\\",\\\"id\\\":\\\"16308\\\",\\\"chain\\\":\\\"TRON\\\",\\\"renderable\\\":\\\"App_Admin_Forms_Withdraw_SendTxForm\\\",\\\"_trans_\\\":\\\"user-withdraw\\\"}\",\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/form\"}',
        '2024-01-07 19:42:33', '2024-01-07 19:42:33');
INSERT INTO `admin_operation_log` (`id`, `user_id`, `path`, `method`, `ip`, `input`, `created_at`, `updated_at`)
VALUES (52, 1, 'admin/dcat-api/action', 'POST', '127.0.0.1',
        '{\"action\":\"1\",\"_action\":\"App_Admin_Actions_Grid_Withdraw_SendTxBatchGrid\",\"_key\":[\"16308\",\"16307\"],\"_token\":\"0B8VnCe51qsKqLLuhoG3Y58h609RTcdIev4MGkde\",\"s\":\"\\/admin\\/dcat-api\\/action\"}',
        '2024-01-07 19:59:02', '2024-01-07 19:59:02');
COMMIT;

-- ----------------------------
-- Table structure for admin_permission_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_permission_menu`;
CREATE TABLE `admin_permission_menu`
(
    `permission_id` bigint(20) NOT NULL,
    `menu_id`       bigint(20) NOT NULL,
    `created_at`    timestamp  NULL DEFAULT NULL,
    `updated_at`    timestamp  NULL DEFAULT NULL,
    UNIQUE KEY `admin_permission_menu_permission_id_menu_id_unique` (`permission_id`, `menu_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_permission_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions`
(
    `id`          bigint(20) unsigned                    NOT NULL AUTO_INCREMENT,
    `name`        varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug`        varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `http_method` varchar(255) COLLATE utf8mb4_unicode_ci         DEFAULT NULL,
    `http_path`   text COLLATE utf8mb4_unicode_ci,
    `order`       int(11)                                NOT NULL DEFAULT '0',
    `parent_id`   bigint(20)                             NOT NULL DEFAULT '0',
    `created_at`  timestamp                              NULL     DEFAULT NULL,
    `updated_at`  timestamp                              NULL     DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_permissions_slug_unique` (`slug`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 7
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (1, 'Auth management', 'auth-management', '', '', 1, 0, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (2, 'Users', 'users', '', '/auth/users*', 2, 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (3, 'Roles', 'roles', '', '/auth/roles*', 3, 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (4, 'Permissions', 'permissions', '', '/auth/permissions*', 4, 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (5, 'Menu', 'menu', '', '/auth/menu*', 5, 1, '2023-12-23 18:13:47', NULL);
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `order`, `parent_id`, `created_at`,
                                 `updated_at`)
VALUES (6, 'Extension', 'extension', '', '/auth/extensions*', 6, 1, '2023-12-23 18:13:47', NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_menu`;
CREATE TABLE `admin_role_menu`
(
    `role_id`    bigint(20) NOT NULL,
    `menu_id`    bigint(20) NOT NULL,
    `created_at` timestamp  NULL DEFAULT NULL,
    `updated_at` timestamp  NULL DEFAULT NULL,
    UNIQUE KEY `admin_role_menu_role_id_menu_id_unique` (`role_id`, `menu_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for admin_role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_permissions`;
CREATE TABLE `admin_role_permissions`
(
    `role_id`       bigint(20) NOT NULL,
    `permission_id` bigint(20) NOT NULL,
    `created_at`    timestamp  NULL DEFAULT NULL,
    `updated_at`    timestamp  NULL DEFAULT NULL,
    UNIQUE KEY `admin_role_permissions_role_id_permission_id_unique` (`role_id`, `permission_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for admin_role_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_users`;
CREATE TABLE `admin_role_users`
(
    `role_id`    bigint(20) NOT NULL,
    `user_id`    bigint(20) NOT NULL,
    `created_at` timestamp  NULL DEFAULT NULL,
    `updated_at` timestamp  NULL DEFAULT NULL,
    UNIQUE KEY `admin_role_users_role_id_user_id_unique` (`role_id`, `user_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_role_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_users` (`role_id`, `user_id`, `created_at`, `updated_at`)
VALUES (1, 1, '2023-12-23 18:13:47', '2023-12-23 18:13:47');
INSERT INTO `admin_role_users` (`role_id`, `user_id`, `created_at`, `updated_at`)
VALUES (2, 2, '2023-12-24 18:48:35', '2023-12-24 18:48:35');
COMMIT;

-- ----------------------------
-- Table structure for admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `admin_roles`;
CREATE TABLE `admin_roles`
(
    `id`         bigint(20) unsigned                    NOT NULL AUTO_INCREMENT,
    `name`       varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug`       varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp                              NULL DEFAULT NULL,
    `updated_at` timestamp                              NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_roles_slug_unique` (`slug`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 3
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_roles
-- ----------------------------
BEGIN;
INSERT INTO `admin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`)
VALUES (1, 'Administrator', 'administrator', '2023-12-23 18:13:47', '2023-12-23 18:13:47');
INSERT INTO `admin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`)
VALUES (2, '财务', 'finance', '2023-12-24 18:02:53', '2023-12-24 18:19:29');
COMMIT;

-- ----------------------------
-- Table structure for admin_settings
-- ----------------------------
DROP TABLE IF EXISTS `admin_settings`;
CREATE TABLE `admin_settings`
(
    `slug`       varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value`      longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `created_at` timestamp                               NULL DEFAULT NULL,
    `updated_at` timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`slug`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_settings
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users`
(
    `id`             bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `username`       varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password`       varchar(80) COLLATE utf8mb4_unicode_ci  NOT NULL,
    `name`           varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `avatar`         varchar(255) COLLATE utf8mb4_unicode_ci      DEFAULT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci      DEFAULT NULL,
    `created_at`     timestamp                               NULL DEFAULT NULL,
    `updated_at`     timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admin_users_username_unique` (`username`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 3
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of admin_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_users` (`id`, `username`, `password`, `name`, `avatar`, `remember_token`, `created_at`, `updated_at`)
VALUES (1, 'admin', '$2y$10$d6DgA8osZodEiXJkGnJ8FOtu5DUyWfHpnRxa1gbGc1aStBxR1T4gi', 'Administrator', NULL, NULL,
        '2023-12-23 18:13:47', '2023-12-23 18:13:47');
INSERT INTO `admin_users` (`id`, `username`, `password`, `name`, `avatar`, `remember_token`, `created_at`, `updated_at`)
VALUES (2, 'finance', '$2y$10$P8lLxlJFguZK2t9EWHwnpOv7UM1BYDE3dU0kEpXcjSNqsEY1pInVK', '财务1', NULL, NULL,
        '2023-12-24 18:07:09', '2023-12-24 18:31:51');
COMMIT;

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs`
(
    `id`         bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `uuid`       varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `queue`      text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `payload`    longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `exception`  longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `failed_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`
(
    `id`        int(10) unsigned                        NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch`     int(11)                                 NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 9
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (3, '2016_01_04_173148_create_admin_tables', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (4, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (5, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (6, '2020_09_07_090635_create_admin_settings_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (7, '2020_09_22_015815_create_admin_extensions_table', 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES (8, '2020_11_01_083237_update_admin_menu_table', 1);
COMMIT;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets`
(
    `email`      varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token`      varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp                               NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of password_resets
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for personal_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE `personal_access_tokens`
(
    `id`             bigint(20) unsigned                     NOT NULL AUTO_INCREMENT,
    `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tokenable_id`   bigint(20) unsigned                     NOT NULL,
    `name`           varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token`          varchar(64) COLLATE utf8mb4_unicode_ci  NOT NULL,
    `abilities`      text COLLATE utf8mb4_unicode_ci,
    `last_used_at`   timestamp                               NULL DEFAULT NULL,
    `created_at`     timestamp                               NULL DEFAULT NULL,
    `updated_at`     timestamp                               NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
    KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`, `tokenable_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------
BEGIN;
COMMIT;

